SDAC

TDAScript Members

TDAScript class overview.

Properties

Name Description

Connection

Used to specify the connection in which the script will be executed.

DataSet

Refers to a dataset that holds the result set of query execution.

Debug

Used to display the script execution and all its parameter values.

Delimiter

Used to set the delimiter string that separates script statements.

EndLine

Used to get the current statement last line number in a script.

EndOffset

Used to get the offset in the last line of the current statement.

EndPos

Used to get the end position of the current statement.

Macros

Used to change SQL script text in design- or run-time easily.

SQL

Used to get or set script text.

StartLine

Used to get the current statement start line number in a script.

StartOffset

Used to get the offset in the first line of the current statement.

StartPos

Used to get the start position of the current statement in a script.

Statements

Contains a list of statements obtained from the SQL property.

Methods

Name Description

BreakExec

Stops script execution.

ErrorOffset

Used to get the offset of the statement if the Execute method raised an exception.

Execute

Executes a script.

ExecuteFile

Executes SQL statements contained in a file.

ExecuteNext

Executes the next statement in the script and then stops.

ExecuteStream

Executes SQL statements contained in a stream object.

FindMacro

Finds a macro with the specified name.

MacroByName

Finds a macro with the specified name.

Events

Name Description

AfterExecute

Occurs after a SQL script execution.

BeforeExecute

Occurs when taking a specific action before executing the current SQL statement is needed.

OnError

Occurs when SQL Server raises an error.
© 1997-2024 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback